Plato’s pizza Sales and Orders Dashboard
19
1. Create a new Dashboard by clicking on New Dashboard. Rename it as Pizza Sales and Orders Dashboard.
2. Click on Dashboard from top Menu and select Show Title.
3. Under Objects, select Floating. Click on size, Range: Width – 1120px, Height – 960 px.
4.
Drag and drop Total Sales sheet to the top left and adjust the size so
that all the numbers are displayed correctly. Click on Layout and select
Border and color = #e6e6e6.
5. Drag and drop Total Orders
sheet below Total Sales and adjust the size so that all the numbers are
displayed correctly. Click on Layout and select Border and color =
#e6e6e6.
6. Drag and drop Hourly Avg Orders sheet next to
Total Sales and adjust the size so that all the numbers are displayed
correctly. Click on Layout and select Border and color = #e6e6e6. Right
click on color legend and uncheck Show Title option. Resize the legend
and place it in the title box of the chart.
7. Click on More options for the chart and select Add Show/Hide button. Click Edit button
Dashboard Item to show = Monthly Avg Orders
Button Style = Text Button
Item shown, Title = Show Hourly Orders, Font = Segoe UI Semibold, Size = 8, Color = White,
Border = None, Background = #5f8d37
Item Hidden, Title = Show Monthly Orders, Font = Segoe UI Semibold, Size = 8, Color =White,
Border = None, Background = #5f8d37
Click OK, adjust the size of the button and place it in the title box of the chart.
8.Drag
and drop Sales by Size sheet next to Total Sales and adjust the size so
that all the numbers are displayed correctly. Click on Layout and
select Border and color = #e6e6e6. Right click on color legend and
uncheck Show Title option. Resize the legend and place it in the title
box of the chart.
9. Drag and drop Sales by Day sheet next
to Total Sales and adjust the size so that all the numbers are
displayed correctly. Click on Layout and select Border and color =
#e6e6e6. Right click on color legend and uncheck Show Title option.
Resize the legend and place it below the title box of the chart.
10.
Drag and drop Sales by Category sheet next to Total Sales and adjust
the size so that all the numbers are displayed correctly. Click on
Layout and select Border and color = #e6e6e6. Right click on color
legend and uncheck Show Title option. Resize the legend and place it
below the title box of the chart.
Follow the Gif files below for step by step instructions:
Tableau Dashboard - Tips and tricks